package com.dingding.special.user.login.dao.sql;

/**
 * 
 * @ClassName: UserLoginSQL 
 * @Description:用户登录所需SQL
 * @author CHEHAUNBO 
 * @date 2016年8月23日 上午9:54:22
 * @since V2.4.0
 * 
 */
public class SpecialUserLoginSQL {

	/**
	 * 用户登录获取客户端所需登录信息
	 * @author CHEHUANBO
	 * @since V2.4.0
	 * 
	 */
	public static final String GET_USER_LOGININF = "SELECT ul.rongCloudToken, ul.aliasId, ul.suid AS userId, spui.telPhone, spui.nickName, spui.sex, spui.userAvatar, spui.userTabloidAvatar, spui.userLevel, ul.userRole, spvi.suvStatus, spods.appointOrderType, spods.distanceFilter, spods.startTime,spods.endTime, spods.voiceAnnouncements FROM specialuserlogin ul LEFT JOIN specialuserinfo spui ON ul.suid = spui.userId LEFT JOIN specialuservehicleinfo spvi ON ul.suid = spvi.userId LEFT JOIN specialorderdesignateset spods ON ul.suid = spods.userId WHERE ul.userName = ?";

}
